using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Tongiao.Config;     
using Tongiao.Entity;
namespace Tongiao.ManagerBase
{
                

     public abstract class Tg_UserInfoManagerBase
    {
        public Tg_UserInfoManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity Insert(Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity Update(Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.Update(obj);             
        }
 
 
        public Tg_UserInfoEntity Delete(Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.Delete(obj);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien AddressCurrent duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByAddressCurrent (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"AddressCurrent");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien AddressCurrent 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByAddressCurrent (string AddressCurrent )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.AddressCurrent = AddressCurrent;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"AddressCurrent");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Birthday duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByBirthday (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Birthday");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Birthday 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByBirthday (DateTime Birthday )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Birthday = Birthday;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Birthday");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByCreatedBy (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByCreatedBy (string CreatedBy )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedBy = CreatedBy;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByCreatedDate (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByCreatedDate (DateTime CreatedDate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedDate = CreatedDate;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien FullName duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByFullName (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"FullName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien FullName 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByFullName (string FullName )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.FullName = FullName;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"FullName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Generate duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByGenerate (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Generate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Generate 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByGenerate (string Generate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Generate = Generate;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Generate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteById (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Id");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Id 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteById (Guid Id )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Id = Id;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Id");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Info duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByInfo (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Info");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Info 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByInfo (string Info )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Info = Info;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Info");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByPassword (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Password");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Password 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByPassword (string Password )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Password = Password;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"Password");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PhoneNumber duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByPhoneNumber (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"PhoneNumber");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PhoneNumber 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByPhoneNumber (string PhoneNumber )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.PhoneNumber = PhoneNumber;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"PhoneNumber");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByUpdatedBy (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByUpdatedBy (string UpdatedBy )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedBy = UpdatedBy;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByUpdatedDate (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByUpdatedDate (DateTime UpdatedDate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedDate = UpdatedDate;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByUserName (Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"UserName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UserName 
        /// </summary>
        /// <returns>Tg_UserInfoEntity</returns>
        public Tg_UserInfoEntity DeleteByUserName (string UserName )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UserName = UserName;  
            return (Tg_UserInfoEntity)Adapter.DeleteByField(obj,"UserName");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public Tg_UserInfoEntity Select(Tg_UserInfoEntity obj)
        { 
            return (Tg_UserInfoEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(Tg_UserInfoEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(Tg_UserInfoEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new Tg_UserInfoEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new Tg_UserInfoEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<Tg_UserInfoEntity> SelectAllLST()
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new Tg_UserInfoEntity()),new Tg_UserInfoEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<Tg_UserInfoEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new Tg_UserInfoEntity(),option),new Tg_UserInfoEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressCurrent duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddressCurrent (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"AddressCurrent");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressCurrent duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddressCurrent (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"AddressCurrent",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressCurrent duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByAddressCurrentLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AddressCurrent"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressCurrent duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByAddressCurrentLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"AddressCurrent",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressCurrent 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddressCurrent (string AddressCurrent )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.AddressCurrent = AddressCurrent;  
            return Adapter.SelectByField(obj,"AddressCurrent");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressCurrent duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddressCurrent (string AddressCurrent, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.AddressCurrent = AddressCurrent;  
            return Adapter.SelectByField(obj,"AddressCurrent",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressCurrent 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByAddressCurrentLST (string AddressCurrent )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.AddressCurrent = AddressCurrent;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AddressCurrent"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressCurrent duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByAddressCurrentLST (string AddressCurrent, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.AddressCurrent = AddressCurrent;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AddressCurrent",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Birthday duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBirthday (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"Birthday");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Birthday duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBirthday (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Birthday",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Birthday duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByBirthdayLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Birthday"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Birthday duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByBirthdayLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Birthday",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Birthday 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBirthday (DateTime Birthday )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Birthday = Birthday;  
            return Adapter.SelectByField(obj,"Birthday");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Birthday duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBirthday (DateTime Birthday, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Birthday = Birthday;  
            return Adapter.SelectByField(obj,"Birthday",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Birthday 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByBirthdayLST (DateTime Birthday )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Birthday = Birthday;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Birthday"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Birthday duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByBirthdayLST (DateTime Birthday, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Birthday = Birthday;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Birthday",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByCreatedByLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByCreatedByLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedBy",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByCreatedByLST (string CreatedBy )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByCreatedByLST (string CreatedBy, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByCreatedDateLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByCreatedDateLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedDate",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByCreatedDateLST (DateTime CreatedDate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByCreatedDateLST (DateTime CreatedDate, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FullName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFullName (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"FullName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FullName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFullName (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"FullName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FullName duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByFullNameLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FullName"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FullName duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByFullNameLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"FullName",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FullName 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFullName (string FullName )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.FullName = FullName;  
            return Adapter.SelectByField(obj,"FullName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FullName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFullName (string FullName, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.FullName = FullName;  
            return Adapter.SelectByField(obj,"FullName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FullName 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByFullNameLST (string FullName )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.FullName = FullName;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FullName"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FullName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByFullNameLST (string FullName, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.FullName = FullName;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FullName",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Generate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByGenerate (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"Generate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Generate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByGenerate (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Generate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Generate duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByGenerateLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Generate"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Generate duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByGenerateLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Generate",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Generate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByGenerate (string Generate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Generate = Generate;  
            return Adapter.SelectByField(obj,"Generate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Generate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByGenerate (string Generate, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Generate = Generate;  
            return Adapter.SelectByField(obj,"Generate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Generate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByGenerateLST (string Generate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Generate = Generate;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Generate"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Generate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByGenerateLST (string Generate, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Generate = Generate;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Generate",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"Id");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Id",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByIdLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByIdLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Id",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (Guid Id )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Id = Id;  
            return Adapter.SelectByField(obj,"Id");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (Guid Id, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Id = Id;  
            return Adapter.SelectByField(obj,"Id",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByIdLST (Guid Id )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Id = Id;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByIdLST (Guid Id, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Id = Id;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Info duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByInfo (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"Info");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Info duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByInfo (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Info",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Info duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByInfoLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Info"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Info duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByInfoLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Info",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Info 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByInfo (string Info )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Info = Info;  
            return Adapter.SelectByField(obj,"Info");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Info duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByInfo (string Info, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Info = Info;  
            return Adapter.SelectByField(obj,"Info",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Info 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByInfoLST (string Info )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Info = Info;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Info"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Info duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByInfoLST (string Info, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Info = Info;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Info",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPassword (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"Password");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPassword (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Password",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByPasswordLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Password"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByPasswordLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Password",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPassword (string Password )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Password = Password;  
            return Adapter.SelectByField(obj,"Password");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPassword (string Password, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Password = Password;  
            return Adapter.SelectByField(obj,"Password",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByPasswordLST (string Password )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Password = Password;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Password"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByPasswordLST (string Password, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.Password = Password;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Password",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PhoneNumber duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPhoneNumber (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"PhoneNumber");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PhoneNumber duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPhoneNumber (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"PhoneNumber",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PhoneNumber duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByPhoneNumberLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PhoneNumber"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PhoneNumber duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByPhoneNumberLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"PhoneNumber",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PhoneNumber 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPhoneNumber (string PhoneNumber )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.PhoneNumber = PhoneNumber;  
            return Adapter.SelectByField(obj,"PhoneNumber");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PhoneNumber duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPhoneNumber (string PhoneNumber, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.PhoneNumber = PhoneNumber;  
            return Adapter.SelectByField(obj,"PhoneNumber",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PhoneNumber 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByPhoneNumberLST (string PhoneNumber )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.PhoneNumber = PhoneNumber;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PhoneNumber"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PhoneNumber duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByPhoneNumberLST (string PhoneNumber, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.PhoneNumber = PhoneNumber;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PhoneNumber",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByUpdatedByLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByUpdatedByLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedBy",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByUpdatedByLST (string UpdatedBy )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByUpdatedByLST (string UpdatedBy, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByUpdatedDateLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByUpdatedDateLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedDate",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByUpdatedDateLST (DateTime UpdatedDate )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByUpdatedDateLST (DateTime UpdatedDate, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserName (Tg_UserInfoEntity obj)
        { 
            return Adapter.SelectByField(obj,"UserName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserName (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UserName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByUserNameLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserName"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectByUserNameLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UserName",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserName (string UserName )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UserName = UserName;  
            return Adapter.SelectByField(obj,"UserName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserName (string UserName, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UserName = UserName;  
            return Adapter.SelectByField(obj,"UserName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByUserNameLST (string UserName )
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UserName = UserName;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserName"),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<Tg_UserInfoEntity> SelectByUserNameLST (string UserName, SelectOptions option)
        { 
            Tg_UserInfoEntity obj = new Tg_UserInfoEntity();
            obj.UserName = UserName;  
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserName",option),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectWithConditionLST (Tg_UserInfoEntity obj)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new Tg_UserInfoEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<Tg_UserInfoEntity></returns>
        public List<Tg_UserInfoEntity> SelectWithConditionLST (Tg_UserInfoEntity obj,SelectOptions option)
        { 
            return  (List<Tg_UserInfoEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new Tg_UserInfoEntity());
        }

}
}
